#/bin/bash

DB_IP='127.0.0.1'
DB_USER=root
DB_NAME=testdb
DB_PASSWD=Root_123 

sql="
drop database if exists $DB_NAME;
create database $DB_NAME character set utf8;
"

echo $sql 
mysql -h$DB_IP -u$DB_USER -p$DB_PASSWD $DB_NAME -e "$sql"
mysql -h$DB_IP -u$DB_USER -p$DB_PASSWD $DB_NAME < server.sql


